-----------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  J:\RenanWork\schatz-exp\isq-tables.log
  log type:  text
 opened on:  24 May 2011, 20:50:06

. 
. /**Check distribution of stimuli across groups. Always 1-3 in each group except once wi
> th no one with "no quotation." **/
. tab groupn cond

     ID of |
     Group |                   Condition (Source)
Discussion |      Bush  Ambassado  Ordinary   No attrib  No quotat |     Total
-----------+-------------------------------------------------------+----------
         1 |         2          2          2          2          2 |        10 
         2 |         2          2          2          2          1 |         9 
         3 |         2          2          2          2          2 |        10 
         4 |         3          3          3          1          2 |        12 
         5 |         3          2          2          2          2 |        11 
         6 |         2          2          2          2          1 |         9 
         7 |         2          2          2          2          2 |        10 
         8 |         1          2          2          1          2 |         8 
         9 |         2          3          2          2          2 |        11 
        10 |         2          2          2          2          0 |         8 
        11 |         2          2          2          2          2 |        10 
        12 |         2          2          2          3          2 |        11 
-----------+-------------------------------------------------------+----------
     Total |        25         26         25         23         20 |       119 


. 
. /**p6 (fn 10): Creates index using all four variables measuring opinion towards US**/
. alpha usop1 usharm1 ussup1 usapp1

Test scale = mean(unstandardized items)

Average interitem covariance:     .7384758
Number of items in the scale:            4
Scale reliability coefficient:      0.7969

. alpha usop2 usharm2 ussup2 usapp2

Test scale = mean(unstandardized items)

Average interitem covariance:     .5885443
Number of items in the scale:            4
Scale reliability coefficient:      0.8234

. corr usindexpre4 usindexpos4
(obs=113)

             | usind~e4 usind~s4
-------------+------------------
 usindexpre4 |   1.0000
 usindexpos4 |   0.6781   1.0000


. 
. /** Table 1: Mean by treatment **/
. tabstat q40 usindexpre4 usindexpos4, stats(mean) by(cond) f(%5.3f)

Summary statistics: mean
  by categories of: cond (Condition (Source))

            cond |       q40  usind~e4  usind~s4
-----------------+------------------------------
            Bush |     2.920     2.423     2.681
      Ambassador |     4.250     2.724     3.045
Ordinary America |     3.958     3.117     3.097
  No attribution |     4.143     2.873     3.056
    No quotation |         .     3.162     3.075
-----------------+------------------------------
           Total |     3.798     2.843     2.986
------------------------------------------------

. /** Comments on Table 1 (pp. 8-9, including fn 12, 13 and 14) **/
. ttest q40 if cond==1 | cond==4, by(cond)

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. Err.   Std. Dev.   [95% Conf. Interval]
---------+--------------------------------------------------------------------
    Bush |      25        2.92    .2939388    1.469694     2.31334     3.52666
No attri |      21    4.142857    .2869023    1.314751    3.544389    4.741325
---------+--------------------------------------------------------------------
combined |      46    3.478261    .2235833    1.516416    3.027941    3.928581
---------+--------------------------------------------------------------------
    diff |           -1.222857    .4148189                -2.05887   -.3868446
------------------------------------------------------------------------------
    diff = mean(Bush) - mean(No attri)                            t =  -2.9479
Ho: diff = 0                                     degrees of freedom =       44

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.0026         Pr(|T| > |t|) = 0.0051          Pr(T > t) = 0.9974

. ttest q40, by(bush)

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. Err.   Std. Dev.   [95% Conf. Interval]
---------+--------------------------------------------------------------------
       0 |      69    4.115942    .1566054    1.300862    3.803441    4.428443
       1 |      25        2.92    .2939388    1.469694     2.31334     3.52666
---------+--------------------------------------------------------------------
combined |      94    3.797872    .1486458    1.441175    3.502691    4.093053
---------+--------------------------------------------------------------------
    diff |            1.195942     .314427                .5714628    1.820421
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =   3.8036
Ho: diff = 0                                     degrees of freedom =       92

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.9999         Pr(|T| > |t|) = 0.0003          Pr(T > t) = 0.0001

. ttest usindexpre4, by(bush)

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. Err.   Std. Dev.   [95% Conf. Interval]
---------+--------------------------------------------------------------------
       0 |      93    2.956093    .1021939    .9855226    2.753127    3.159059
       1 |      25    2.423333    .1728653    .8643264    2.066557     2.78011
---------+--------------------------------------------------------------------
combined |     118     2.84322     .090421    .9822239    2.664146    3.022294
---------+--------------------------------------------------------------------
    diff |            .5327599    .2166555                .1036463    .9618734
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =   2.4590
Ho: diff = 0                                     degrees of freedom =      116

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.9923         Pr(|T| > |t|) = 0.0154          Pr(T > t) = 0.0077

. /**reference taken out in final draft**/
. oneway usindexpre4 cond, tab

            |   Summary of mean(unstandardized
  Condition |               items)
   (Source) |        Mean   Std. Dev.       Freq.
------------+------------------------------------
       Bush |   2.4233333   .86432643          25
  Ambassado |    2.724359   .88561632          26
  Ordinary  |   3.1166667   .93107366          25
  No attrib |   2.8731884   .96264497          23
  No quotat |   3.1622807   1.1913635          19
------------+------------------------------------
      Total |   2.8432203   .98222386         118

                        Analysis of Variance
    Source              SS         df      MS            F     Prob > F
------------------------------------------------------------------------
Between groups      8.59912511      4   2.14978128      2.33     0.0603
 Within groups      104.278229    113   .922816189
------------------------------------------------------------------------
    Total           112.877354    117   .964763713

Bartlett's test for equal variances:  chi2(4) =   2.7457  Prob>chi2 = 0.601

. ttest usindexpre4, by(noq)

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. Err.   Std. Dev.   [95% Conf. Interval]
---------+--------------------------------------------------------------------
       0 |      99    2.781987    .0936137    .9314445    2.596213     2.96776
       1 |      19    3.162281    .2733175    1.191363    2.588062      3.7365
---------+--------------------------------------------------------------------
combined |     118     2.84322     .090421    .9822239    2.664146    3.022294
---------+--------------------------------------------------------------------
    diff |           -.3802942    .2445345               -.8646255    .1040372
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =  -1.5552
Ho: diff = 0                                     degrees of freedom =      116

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.0613         Pr(|T| > |t|) = 0.1226          Pr(T > t) = 0.9387

. 
. /**Difference between usop1 and usop2 pg 9**/
. tab usopchg

    usopchg |      Freq.     Percent        Cum.
------------+-----------------------------------
         -3 |          1        0.95        0.95
         -2 |          6        5.71        6.67
         -1 |         13       12.38       19.05
          0 |         50       47.62       66.67
          1 |         21       20.00       86.67
          2 |          9        8.57       95.24
          3 |          4        3.81       99.05
          4 |          1        0.95      100.00
------------+-----------------------------------
      Total |        105      100.00

. 
. /**More consensus views of the US. SD of index is reported, but results are similar for
>  direct question- USOP. 
> Fewer strongly negative opinions can be seen with the changes before/after discussion a
> t the 10th & 90th percentile **/
. tabstat usop1 usop2 usindexpre4 usindexpos4, s(mean p10 median p90 sd iqr) c(s) f(%5.3g
> )

    variable |      mean       p10       p50       p90        sd       iqr
-------------+------------------------------------------------------------
       usop1 |       2.9         1         3         4      1.17         2
       usop2 |      3.18         2         3         4      1.03         2
 usindexpre4 |      2.84       1.5      2.88         4      .982       1.5
 usindexpos4 |         3         2         3         4      .846      1.25
--------------------------------------------------------------------------

. sdtest usindexpre4=usindexpos4

Variance ratio test
------------------------------------------------------------------------------
Variable |     Obs        Mean    Std. Err.   Std. Dev.   [95% Conf. Interval]
---------+--------------------------------------------------------------------
usind~e4 |     118     2.84322     .090421    .9822239    2.664146    3.022294
usind~s4 |     116    2.997126    .0785743    .8462714    2.841486    3.152767
---------+--------------------------------------------------------------------
combined |     234    2.919516    .0600525    .9186272      2.8012    3.037831
------------------------------------------------------------------------------
    ratio = sd(usindexpre4) / sd(usindexpos4)                     f =   1.3471
Ho: ratio = 1                                    degrees of freedom = 117, 115

    Ha: ratio < 1               Ha: ratio != 1                 Ha: ratio > 1
  Pr(F < f) = 0.9449         2*Pr(F > f) = 0.1103           Pr(F > f) = 0.0551

. sdtest usop2=usop1

Variance ratio test
------------------------------------------------------------------------------
Variable |     Obs        Mean    Std. Err.   Std. Dev.   [95% Conf. Interval]
---------+--------------------------------------------------------------------
   usop2 |     112    3.178571    .0976018     1.03292    2.985167    3.371976
   usop1 |     113    2.902655    .1102839    1.172334    2.684141    3.121168
---------+--------------------------------------------------------------------
combined |     225        3.04     .074087    1.111306    2.894003    3.185997
------------------------------------------------------------------------------
    ratio = sd(usop2) / sd(usop1)                                 f =   0.7763
Ho: ratio = 1                                    degrees of freedom = 111, 112

    Ha: ratio < 1               Ha: ratio != 1                 Ha: ratio > 1
  Pr(F < f) = 0.0915         2*Pr(F < f) = 0.1830           Pr(F > f) = 0.9085

. 
. /**Regression to the mean discussion on pg 9, fn 15 
> (Controls are ambiguous- corr is the same for no attribution and no quote**/
. corr usindexpre4 usindexpos4 if bush==1
(obs=24)

             | usind~e4 usind~s4
-------------+------------------
 usindexpre4 |   1.0000
 usindexpos4 |   0.7898   1.0000


. corr usindexpre4 usindexpos4 if noatt==1
(obs=21)

             | usind~e4 usind~s4
-------------+------------------
 usindexpre4 |   1.0000
 usindexpos4 |   0.7449   1.0000


. corr usindexpre4 usindexpos4 if noq==1
(obs=18)

             | usind~e4 usind~s4
-------------+------------------
 usindexpre4 |   1.0000
 usindexpos4 |   0.7410   1.0000


. corr usindexpre4 usindexpos4 if noq==1 | noatt==1
(obs=39)

             | usind~e4 usind~s4
-------------+------------------
 usindexpre4 |   1.0000
 usindexpos4 |   0.7401   1.0000


. 
. /** Table 2 Pre Discussion and Post Discussion DV= index **/
. xi: regress usindexpre4 bush ambd ordam noatt i.location q7 relig age educ2
i.location        _Ilocation_1-5      (naturally coded; _Ilocation_5 omitted)

      Source |       SS       df       MS              Number of obs =     112
-------------+------------------------------           F( 12,    99) =    1.79
       Model |   18.365194    12  1.53043283           Prob > F      =  0.0598
    Residual |  84.5911556    99  .854456117           R-squared     =  0.1784
-------------+------------------------------           Adj R-squared =  0.0788
       Total |   102.95635   111  .927534681           Root MSE      =  .92437

------------------------------------------------------------------------------
 usindexpre4 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
        bush |  -.7914065   .2928131    -2.70   0.008    -1.372411   -.2104019
        ambd |  -.4019898   .2937442    -1.37   0.174    -.9848419    .1808624
       ordam |  -.1052651   .2957263    -0.36   0.723    -.6920501      .48152
       noatt |  -.3100267   .2953153    -1.05   0.296    -.8959963     .275943
_Ilocation_1 |  -.3372907   .3370801    -1.00   0.319    -1.006131    .3315494
_Ilocation_2 |  -.0545042   .3098368    -0.18   0.861    -.6692876    .5602793
_Ilocation_3 |  -.0003233   .3436456    -0.00   0.999    -.6821908    .6815441
_Ilocation_4 |  -.2774603   .3352611    -0.83   0.410    -.9426912    .3877705
          q7 |   .1519038    .093049     1.63   0.106    -.0327256    .3365331
       relig |   .0370924    .089338     0.42   0.679    -.1401735    .2143583
         age |    .025827   .0108883     2.37   0.020     .0042221    .0474318
       educ2 |   .5916277   .2272229     2.60   0.011     .1407682    1.042487
       _cons |   1.398213    .649879     2.15   0.034     .1087123    2.687714
------------------------------------------------------------------------------

. estimates store rgpre4f

. xi: regress usindexpos4 bush ambd ordam noatt i.location us4group ussd4group usindexpre
> 4
i.location        _Ilocation_1-5      (naturally coded; _Ilocation_5 omitted)

      Source |       SS       df       MS              Number of obs =     113
-------------+------------------------------           F( 11,   101) =   12.88
       Model |  45.2562782    11  4.11420711           Prob > F      =  0.0000
    Residual |  32.2539232   101  .319345774           R-squared     =  0.5839
-------------+------------------------------           Adj R-squared =  0.5386
       Total |  77.5102014   112   .69205537           Root MSE      =  .56511

------------------------------------------------------------------------------
 usindexpos4 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
        bush |  -.0100409   .1824444    -0.06   0.956    -.3719614    .3518796
        ambd |   .2373729   .1756693     1.35   0.180    -.1111078    .5858537
       ordam |    .011069    .176879     0.06   0.950    -.3398113    .3619494
       noatt |   .0504028   .1830374     0.28   0.784    -.3126942    .4134999
_Ilocation_1 |   .4090866   .2139128     1.91   0.059    -.0152589     .833432
_Ilocation_2 |   .5613029   .1939015     2.89   0.005     .1766545    .9459513
_Ilocation_3 |   .2682749   .2103059     1.28   0.205    -.1489153    .6854651
_Ilocation_4 |   .7402869   .2171921     3.41   0.001     .3094361    1.171138
    us4group |   .2635957   .1316542     2.00   0.048     .0024292    .5247621
  ussd4group |  -.4201618   .2129554    -1.97   0.051     -.842608    .0022845
 usindexpre4 |   .5672799   .0655262     8.66   0.000     .4372934    .6972663
       _cons |   .4652776   .4602278     1.01   0.314    -.4476905    1.378246
------------------------------------------------------------------------------

. estimates store rgpos4s

. 
. estimates table rgpre4f rgpos4s, b(%6.3f) star (.01 .05 .1)

----------------------------------------
    Variable |  rgpre4f      rgpos4s    
-------------+--------------------------
        bush |  -0.791***    -0.010     
        ambd |  -0.402        0.237     
       ordam |  -0.105        0.011     
       noatt |  -0.310        0.050     
_Ilocation_1 |  -0.337        0.409*    
_Ilocation_2 |  -0.055        0.561***  
_Ilocation_3 |  -0.000        0.268     
_Ilocation_4 |  -0.277        0.740***  
          q7 |   0.152                  
       relig |   0.037                  
         age |   0.026**                
       educ2 |   0.592**                
    us4group |                0.264**   
  ussd4group |               -0.420*    
 usindexpre4 |                0.567***  
       _cons |   1.398**      0.465     
----------------------------------------
     legend: * p<.1; ** p<.05; *** p<.01

. 
. /** Appendix **/
. sum usop1 usharm1 ussup1 usapp1 usindexpre4 usop2 usharm2 ussup2 usapp2 usindexpos4

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       usop1 |       113    2.902655    1.172334          1          5
     usharm1 |       105     2.92381    1.214458          1          5
      ussup1 |       101    2.871287    1.205515          1          5
      usapp1 |        94    2.542553    1.300661          1          5
 usindexpre4 |       118     2.84322    .9822239          1          5
-------------+--------------------------------------------------------
       usop2 |       112    3.178571     1.03292          1          5
     usharm2 |       107     3.11215    1.012442          1          5
      ussup2 |       108    3.018519    1.013751          1          5
      usapp2 |       105    2.609524    1.122285          1          5
 usindexpos4 |       116    2.997126    .8462714          1          5

. tab groupn location

     ID of |
     Group |                 Location / Interviewer
Discussion |   Bishkek        Osh   Dushanbe    Khujand     Kulyab |     Total
-----------+-------------------------------------------------------+----------
         1 |        10          0          0          0          0 |        10 
         2 |         9          0          0          0          0 |         9 
         3 |        10          0          0          0          0 |        10 
         4 |         0         12          0          0          0 |        12 
         5 |         0         11          0          0          0 |        11 
         6 |         0          9          0          0          0 |         9 
         7 |         0          0          0          0         10 |        10 
         8 |         0          0          0          0         10 |        10 
         9 |         0          0         11          0          0 |        11 
        10 |         0          0          8          0          0 |         8 
        11 |         0          0          0         10          0 |        10 
        12 |         0          0          0         11          0 |        11 
-----------+-------------------------------------------------------+----------
     Total |        29         32         19         21         20 |       121 


. tab groupn cond

     ID of |
     Group |                   Condition (Source)
Discussion |      Bush  Ambassado  Ordinary   No attrib  No quotat |     Total
-----------+-------------------------------------------------------+----------
         1 |         2          2          2          2          2 |        10 
         2 |         2          2          2          2          1 |         9 
         3 |         2          2          2          2          2 |        10 
         4 |         3          3          3          1          2 |        12 
         5 |         3          2          2          2          2 |        11 
         6 |         2          2          2          2          1 |         9 
         7 |         2          2          2          2          2 |        10 
         8 |         1          2          2          1          2 |         8 
         9 |         2          3          2          2          2 |        11 
        10 |         2          2          2          2          0 |         8 
        11 |         2          2          2          2          2 |        10 
        12 |         2          2          2          3          2 |        11 
-----------+-------------------------------------------------------+----------
     Total |        25         26         25         23         20 |       119 


. sum usindexpos4 if usindexpre4~=.

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
 usindexpos4 |       113    2.981563    .8318987          1          5

. table groupn, c(mean female mean age mean q7 mean relig mean usindexpre4) f(%5.2g)

--------------------------------------------------------------------------------
ID of     |
Group     |
Discussio |
n         | mean(female)     mean(age)      mean(q7)   mean(relig)  mean(usin~4)
----------+---------------------------------------------------------------------
        1 |           .8            29           3.6           2.4           2.3
        2 |          .33            28           3.8           1.9           2.7
        3 |           .5            42           3.5             3           3.4
        4 |          .33            30           2.8           2.2           2.4
        5 |         .091            37           3.7           3.1           3.4
        6 |          .11            34           3.7           2.9           2.7
        7 |            0            34           2.9           3.7           3.4
        8 |            0            32           2.5           3.2           2.4
        9 |          .18            30           3.1           3.3             3
       10 |          .63            28           3.5           2.8           2.9
       11 |           .4            32           2.9           3.2           3.4
       12 |            0            28           3.5           4.4             2
--------------------------------------------------------------------------------

. tabstat female age q7 relig usindexpre4, s(mean) f(%5.2g)

   stats |    female       age        q7     relig  usind~e4
---------+--------------------------------------------------
    mean |       .28        32       3.3         3       2.8
------------------------------------------------------------

. log close
      name:  <unnamed>
       log:  J:\RenanWork\schatz-exp\isq-tables.log
  log type:  text
 closed on:  24 May 2011, 20:50:07
-----------------------------------------------------------------------------------------
